AdditionalServerProperties

Additional data source connection properties and settings used OPTIONALLY for different server types.

API Section: Objects

Type: Object

Properties

Name

Description

Required

Type

Format

sharedFolderPath

Shared Folder Path

-

string

relativeFolderName

Relative Folder Path

-

string

hiveIP

Hadoop HIVE IP address

-

string

hivePort

Hadoop HIVE port number

-

integer

int32

hdfsIP

Hadoop HDFS IP address

-

string

hdfsPort

Hadoop HDFS port number

-

integer

int32

authMethod

relevant to olap datasources, specify the auth method used against the cube for end user

-

CubeAuthMethod

proxyAccountInUse

Relevant for OLAP, Tabular, Snowflake and SAP BW; specify the effective proxy account to use for connection when supported by the auth type

-

ServerEffectiveUserName

machineAccountFallback

-

boolean

keytabPath

-

string

keytabId

-

string

uuid

awsAccessKeyId

-

string

awsSecretAccessKey

-

string

awsRegion

-

string

awsBucketName

-

string

bulkWritingType

-

string

athenaRegion

-

string

s3StagingDir

-

string

resolveColumnLabel

-

boolean

disableDBTables

-

boolean

disableAttributeViews

-

boolean

disableAnalyticViews

-

boolean

disableCalculationViews

-

boolean

hierarchyType

Type of the modeling hierarchy: Drill path, parent-child tree, regular

-

HierarchyType

salesforceSecurityToken

-

string

warehouse

-

string

accessToken

-

string

accessTokenSecret

-

string

consumerKey

-

string

consumerSecret

-

string

useSSL

Use SSL to connect

-

boolean

shouldValidateServerCert

Should validate Server certificate

-

boolean

isCustomCertHostname

Should validate a different hostname than the server hostname

-

boolean

customCertHostname

Hostname in certificate that we should validate

-

string

isCustomKeyStore

Using a different keystore than the java VM keystore?

-

boolean

customKeyStore

Path to custom keystore (in Pyramid server filesystem)

-

string

customKeyStoreType

Custom keystore type (JKS / PKCS12)

-

string

customKeyStorePassword

Keystore password

-

string

isCustomTrustStore

Using a different java trust store than the java VM trust store?

-

boolean

customTrustStore

Path to custom java trust store (in Pyramid server filesystem)

-

string

customTrustStorePassword

Trust store password

-

string

isDatabaseSchema

Treat schemas names as database names in Pyramid

-

boolean

accountId

Account ID

-

string

roleId

Role ID

-

string

sysNumber

-

string

clientNumber

Custom client parameter for SAP HANA and BW

-

string

sncPartnerName

-

string

sapRouter

-

string

bwInfoAreaIconIds

-

string

defaultCulture

Language option for SAP HANA and BW

-

string

urlPortal

-

string

bringNonOleDbComponents

-

boolean

showInfoAreaTree

-

boolean

mdxCompatibility

-

integer

int32

supportsBwFlatQueries

-

boolean

sapBwServerConnectionType

-

string

messageServerHost

-

string

messageServerService

-

string

systemR3Name

-

string

groupServer

-

string

avoidMultiPassAuthentication

-

boolean

msOlapConnectionType

-

string

externalServers

-

ExternalServerData [ ]

odbcDirectQueryOptions

-

OdbcDirectQueryOptions

customJdbcId

Required when serverType is CustomJdbc and specifies which custom jdbc it is

-

string

uuid

customJdbcProps

-

object

sparkTransportMode

Transport mode for Spark connection: Binary, SASL or HTTP or HTTPS

-

string

isOverrideConnectionString

Should we override the connection string - if so, use optionalJdbcParameters to specify the full JDBC connection string

-

boolean

shouldValidateServerCertHostname

Should validate the server certificate's hostname

-

boolean

certValidationCustomRootCaType

The type of the custom root CA to use when validating the server's certificate

-

string

customRootCaCert

Custom root CA certificate used to validate the server's certificate

-

string

defaultTrustStorePassword

Password for the default trust store

-

string

useCustomCertificateConfig

Specify whether to customize the certificate configuration

-

boolean

useClientCertificate

Should the client use an ssl certificate?

-

boolean

clientCertPath

Path to the client's certificate

-

string

clientKeyPath

Path to the client's key

-

string

clientKeyPassword

Password for the client's key

-

string

customTrustStoreType

Custom truststore type (JKS / PKCS12)

-

string

oauthDataSourceSettings

-

OauthDataSourceSettings